-- ----------------------------
-- Table structure for sys_time
-- ----------------------------
DROP TABLE IF EXISTS sys_time;
CREATE TABLE `sys_time`
(
    `id`   BIGINT(20)  NOT NULL AUTO_INCREMENT COMMENT '主键',
    `hour` VARCHAR(32) NOT NULL DEFAULT '' COMMENT '小时',
    `time` VARCHAR(32) NOT NULL DEFAULT '' COMMENT '时间',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  ROW_FORMAT = DYNAMIC COMMENT ='时间';

-- ----------------------------
-- Records of sys_time
-- ----------------------------
BEGIN;
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (1, '00', '00:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (2, '01', '01:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (3, '02', '02:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (4, '03', '03:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (5, '04', '04:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (6, '05', '05:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (7, '06', '06:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (8, '07', '07:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (9, '08', '08:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (10, '09', '09:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (11, '10', '10:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (12, '11', '11:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (13, '12', '12:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (14, '13', '13:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (15, '14', '14:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (16, '15', '15:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (17, '16', '16:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (18, '17', '17:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (19, '18', '18:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (20, '19', '19:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (21, '20', '20:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (22, '21', '21:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (23, '22', '22:00');
INSERT INTO `sys_time` (`id`, `hour`, `time`)
VALUES (24, '23', '23:00');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
